Manage Workspace and Dataset in Power BI

Dynamic Reports

Dynamic reports are reports in which the data can be changed by a developer according to user specifications. Dynamic reports are valuable because a single report can be used for multiple purposes.

What If Parameter

We can use what-if parameters to run scenarios and scenario-type analysis on our data. What-if parameters are powerful additions to our Power BI data models and reports because they enable you to look at historical data to analyze potential outcomes if a different scenario had occurred. 
Additionally, what-if parameters can help us look forward, to predict or forecast what could happen in the future.
We can use what-if parameters in multiple situations, such as to determine the effect of increased sales to deeper discounts, or to let sales consultants see their compensation if they meet certain sales goals or percentages.
Power BI Gateway

Gateway software acts like a bridge; it allows organizations to retain databases and other data sources on their on-premises networks and access that on-premises data in cloud services, such as Power BI and Microsoft Azure Analysis Services.

A gateway facilitates quick, behind-the-scenes communication that flows from a user in the cloud to our on-premises data source and then back again to the cloud.

Two types of on-premises gateways are:

  • Organization mode - Allows multiple users to connect to multiple on-premises data sources and is suitable for complex scenarios.

  • Personal mode - Allows one user to connect to data sources. This type of gateway can be used only with Power BI and it can't be shared with other users, so it is suitable in situations where only one in  organization who creates reports. We will install the gateway on our local computer, which needs to stay online for the gateway to work.

Scheduled Refresh

The Scheduled refresh feature in Power BI allows us to define the frequency and time slots to refresh a particular dataset. Scheduling the refresh of data will save our time because we don't have to manually refresh the data. It also ensures that users can access the most up-to-date data.

Manage and Promote Dataset
Power BI provides two ways to endorse your datasets:

  • Promotion - Promote datasets when they're ready for broad usage. Power BI Admins have permissions to promote datasets.

  • Certification - Request certification for a promoted dataset from an admin user that is defined in the Dataset Certification tenant admin setting. This certification adds another layer of security for datasets. Certification can be a highly selective process, so only the truly reliable and authoritative datasets are used across the organization.

Query caching 

Query Caching is a local caching feature that maintains results on a user and report basis. This service is only available to users with Power BI Premium or Power BI Embedded.  

When using query caching, the query results are only specific to a user, and we can only use query caching on a specific page of a report. Several benefits to using query caching include:  

  • Improvement of the performance of reports, dashboards, and dashboard tiles by reducing loading time and increasing query speed; this notion is especially true for datasets that are not refreshed often and are accessed frequently.  

  • It respects bookmarks and default filters, so even if you enable query caching, any bookmarks that you have created still exist. 

  • Cached query results are specific to the user. 

  • All security labels are followed.   

  • It reduces the load on your dedicated capacity because query caching allows for usage of dedicated capacity and not on the dataset.  

Conclusion:

In this blog I have explored How to create dynamic reports, What-if parameter, schedule refresh, Manage and Promote dataset and query caching.
  

Comments

Post a Comment

Popular posts from this blog

Use DAX iterator functions in Power BI Desktop models

Data Analysis Expressions (DAX) include a set of functions known as  iterator functions . Iterator functions enumerate all rows of a given table and evaluate a given expression for each row. They provide you with flexibility and control over how your model calculations will summarize data. Some DAX Functions are Complex summarization 1. SUMX e.g. : 1.  Revenue = SUMX (Sales, Sales[Sales Amount]) 2. Revenue = SUMX (Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.])) 3. Discount = SUMX ( Sales, Sales[Order Quantity] *( RELATED ('Product'[List Price]) - Sales[Unit Price] ) ) 2. AVERAGEX e.g :1. Revenue Avg = AVERAGEX ( Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.]) ) 2. Revenue Avg Order = AVERAGEX ( VALUES ('Sales Order'[Sales Order]), [Revenue] ) 3. RANKX The  RANKX  DAX function is a special iterator function you can use to calculate ranks. Its syntax is as follows: RANKX (<...
Read more

Different charts in Power BI

Image
  An overview of Chart Types in Power BI As everyone might be aware, Power BI is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.  In this blog, I am going to give an overview of the most widely used chart types in Power BI.   Let's look at some of the most frequently used chart types in Power BI Bar and column charts Stacked Bar and Stacked Column Chart Clustered Bar and Clustered Column Chart Line Chart Area Chart Stacked Area Chart Line and Stacked Column Chart/ Combo Chart Line and Clustered Column Chart/ Combo Chart Ribbon Chart Waterfall Chart Funnel Chart Scatter Chart...
Read more

Modify DAX filter context in Power BI Desktop models

Summary CALCULATE  DAX function to modify filter context in the formulas. The syntax for the CALCULATE function is as follows: CALCULATE (<expression>, [[<filter1>], <filter2>]…) I learned about filter context. And also learned why and how to work with the CALCULATE function to modify filter context by passing in filters. These filters can add or overwrite the filter context, and they can modify filter context when we are passing in special functions like REMOVEFILTERS or KEEPFILTERS. Additionally, I learned that the CALCULATE function can transition row context to filter context, which can be required when we are using measure expressions in calculated columns or iterator functions.
Read more